package db;

import java.sql.SQLException;

import java.util.ArrayList;

import model.Customer;

public interface IFCustomer
{
	public int createCustomer(Customer customer) throws SQLException;
	public int updateCustomer(Customer customer) throws SQLException;

	public Customer searchCustomerID(int id) throws SQLException;;
	public Customer searchCustomerByName(String name) throws SQLException;

	public ArrayList<Customer> getAllCustomers() throws SQLException;
	
	public ArrayList<Customer> searchCustomerName(boolean active, String name) throws SQLException;
	public ArrayList<Customer> searchCustomerPhoneNo(boolean active, String phoneNo) throws SQLException;
	public ArrayList<Customer> searchCustomerEmail(boolean active, String email) throws SQLException;
	public ArrayList<Customer> searchCustomerCity(boolean active, String city) throws SQLException;
	public ArrayList<Customer> searchCustomerCountry(boolean active, String country) throws SQLException;
	public ArrayList<Customer> searchCustomerEverything(boolean active, String search) throws SQLException;
}